速報APP / 商業 / Excel Functions Tutorial (how-to) Videos

Excel Functions Tutorial (how-to) Videos

價格:免費

更新日期:2018-10-02

檔案大小:5.1M

目前版本:1.1.0

版本需求:Android 4.4 以上版本

官方網站:http://www.test4u.eu

Email:info@test4u.eu

聯絡地址:Pindou 6 & Karatza 55135 Kalamaria Thessaloniki Greece

Excel Functions Tutorial (how-to) Videos(圖1)-速報App

This provides the users with the opportunity to get an initial picture about various MS-Excel Functions.

You will find many questions, accompanied by their video-solutions about Microsoft Excel functions. Watching the videosolutions will allow you to get a good idea concerning the skills that you have and assess your level.

The videosolutions are classified into categories so as to let you focus wherever you believe there is some skill shortage. This is how there is almost no time wasted in repeating the parts that you are already familiar with.

The full version is known as TEST4U and constitutes a complete self-study, interactive guide, available since 2003, with more than 700.000 satisfied users.

The candidates can access the full training package in order to be able to respond successfully to Certification Examinations not only for MS-Excel, but also for MS-Word, MS-PowerPoint, MS-Access, Internet & Windows for the Basic or the Advanced level of Microsoft-Certiport Exams, ECDL-ICDL Exams, e.tc.

Functions included:

Error Solving

VALUE, ISERROR, IFERROR, ISFORMULA, ISTEXT, ISBLANK, ISERR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, FORMULATEXT

Text functions

FIND, EXACT, SEARCH, REPLACE, SUBSTITUTE, TEXT, CHAR, T(), REPT, PROPER, UPPER, LOWER, CONCATENATE, LEFT, MID, TRIM, RIGHT

Mathematical Functions

ABS, CEILING, EXP, FLOOR, INT, LN, MOD, PI, ROUND, PI,MROUND, PRODUCT, RAND, RANDBETWEEN, ROUND, ROUNDDOWN, ROUNDUP, SQRT, ABS, SUBTOTAL, SUM, SUMIF, SUMIFS, SUMPRODUCT, SUMSQ

Excel Functions Tutorial (how-to) Videos(圖2)-速報App

Logical functions

AND, IF, OR, IF, NOT

Date and Time functions

DATE, DATEDIF, TODAY, HIDDEN, DATEVALUE, DAY, DAY, MONTH, YEAR, DAYS, DATEDIF, NETWORKDAYS, EDATE, EOMONTH, NETWORKDAYS, NOW, TIMEVALUE, TODAY, WEEKDAY, WORKDAY, WORKDAY.INTL

Lookup functions

CELL, CHOOSE, HLOOKUP, INDEX, INDEX, MATCH,, INDIRECT, ISREF, INDIRECT, LOOKUP, MATCH, SUM, OFFSET, VLOOKUP

Financial Functions

ACCRINT, ACCRINTM, COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, CUMPRINC,CUMIPMT, DB, DDB, DISC, DOLLARDE, DOLLARFR, DURATION, EOQ, FV, INTRATE, IPMT, IRR, LOGNORM.DIST,LOGNORM.INV, MDURATION, MIRR, NPER, NPV, PMT, PPMT, PRICE, PRICEDISC, PRICEMAT, PV, RAND, NORM.INV, RATE, RECEIVED, SLN, SLOPE,INTERCEPT, STDEV.S, SYD, TBILLEQ, TBILLPRICE, TBILLYIELD, VDB, WEIBULL.DIST, XIRR, XNPV, YIELD, YIELDDISC, YIELDMAT

Statistical functions

AVERAGE, AVERAGEIF, AVERAGEIFS, BINOM.DIST, BINOM.INV, BINOM.INV, RAND, CORREL, CORRELATION, COEFFICIENT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, COVAR, COVARIANCE, COVARIANCE.S, COVARIANCE.P, DAVERAGE, DCOUNT, DMIN, DMAX, DSUM, EXPON.DIST, HYPGEOM.DIST, LARGE, MEDIAN, MODE, MIN, NEGBINOM.DIST, NORM.DIST, NORM.INV, PERCENTILE, PERCENTILE.EXC, PERCENTILE.INC, POISSON.DIST, QUARTILE, QUARTILE.INC, QUARTILE.EXC, RANK, SMALL, STDEV, STDEVP,STDEV.P, STDEV.S, SUM, MAX, COUNT, TREND, TRIMMEAN, GEOMEAN, VAR, VAR.S, VAR.P, VARP

Array Formulas

FREQUENCY, SUM,LARGE, TRANSPOSE

Excel Functions Tutorial (how-to) Videos(圖3)-速報App

Cube Functions

CUBEKPIMEMBER, CUBEVALUE, CUBERANKEDMEMBER, CUBESET, CUBESETCOUNT, CUBESETCOUNT, CUBEVALUE

Excel Functions Tutorial (how-to) Videos(圖4)-速報App